Show All
Settings you can save in a template
Formatting
- Cell and sheet formats. Set by using the commands on the Format menu.
- Page formats and print area settings for each sheet.
- Cell styles.
- The number and type of sheets in a workbook.
- Protected and hidden areas of the workbook. You can hide sheets, rows, and columns and prevent changes to worksheet cells.
Text, data, graphics, and formulas
- Text you want to repeat, such as page headers and row and column labels.
- Data, graphics, formulas, charts, and other information.
- Data validation settings.
Toolbars, automation, and Option settings
- Custom toolbars, macros, hyperlinks, and ActiveX controls on forms. To make a custom toolbar available, attach the toolbar to the template.
- Workbook calculation options and window view options. Set with the Options command (Tools menu).